{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pymongo\n",
    "client = pymongo.MongoClient(\"211.87.227.243\",27017)\n",
    "db = client.get_database(\"bookcrawl\")\n",
    "books = db.get_collection(\"books\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "'star_1'"
      ]
     },
     "execution_count": 21,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "books.create_index(\"price\")\n",
    "books.create_index(\"star\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {},
   "outputs": [],
   "source": [
    "cur = books.find({\"price\":{\"$exists\":True}})"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {},
   "outputs": [],
   "source": [
    "prices = cur.distinct(\"price\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "metadata": {},
   "outputs": [],
   "source": [
    "prices_trans_dict = {i:float(i) for i in prices}"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "{'1.1': 1.1,\n",
       " '1.2': 1.2,\n",
       " '1.20': 1.2,\n",
       " '1.3': 1.3,\n",
       " '1.30': 1.3,\n",
       " '1.4': 1.4,\n",
       " '1.5': 1.5,\n",
       " '1.50': 1.5,\n",
       " '1.6': 1.6,\n",
       " '1.60': 1.6,\n",
       " '1.7': 1.7,\n",
       " '1.70': 1.7,\n",
       " '1.8': 1.8,\n",
       " '1.80': 1.8,\n",
       " '1.9': 1.9,\n",
       " '1.90': 1.9,\n",
       " '10.0': 10.0,\n",
       " '10.00': 10.0,\n",
       " '10.1': 10.1,\n",
       " '10.10': 10.1,\n",
       " '10.12': 10.12,\n",
       " '10.2': 10.2,\n",
       " '10.20': 10.2,\n",
       " '10.3': 10.3,\n",
       " '10.30': 10.3,\n",
       " '10.4': 10.4,\n",
       " '10.40': 10.4,\n",
       " '10.5': 10.5,\n",
       " '10.50': 10.5,\n",
       " '10.6': 10.6,\n",
       " '10.60': 10.6,\n",
       " '10.7': 10.7,\n",
       " '10.70': 10.7,\n",
       " '10.73': 10.73,\n",
       " '10.8': 10.8,\n",
       " '10.80': 10.8,\n",
       " '10.9': 10.9,\n",
       " '10.90': 10.9,\n",
       " '10.92': 10.92,\n",
       " '100.0': 100.0,\n",
       " '100.00': 100.0,\n",
       " '100.1': 100.1,\n",
       " '100.10': 100.1,\n",
       " '100.20': 100.2,\n",
       " '100.3': 100.3,\n",
       " '100.30': 100.3,\n",
       " '100.4': 100.4,\n",
       " '100.40': 100.4,\n",
       " '100.50': 100.5,\n",
       " '100.6': 100.6,\n",
       " '100.60': 100.6,\n",
       " '100.7': 100.7,\n",
       " '100.70': 100.7,\n",
       " '100.8': 100.8,\n",
       " '100.80': 100.8,\n",
       " '100.9': 100.9,\n",
       " '100.90': 100.9,\n",
       " '1006.4': 1006.4,\n",
       " '1007.61': 1007.61,\n",
       " '1008': 1008.0,\n",
       " '101.00': 101.0,\n",
       " '101.1': 101.1,\n",
       " '101.10': 101.1,\n",
       " '101.15': 101.15,\n",
       " '101.2': 101.2,\n",
       " '101.20': 101.2,\n",
       " '101.3': 101.3,\n",
       " '101.30': 101.3,\n",
       " '101.4': 101.4,\n",
       " '101.40': 101.4,\n",
       " '101.43': 101.43,\n",
       " '101.5': 101.5,\n",
       " '101.50': 101.5,\n",
       " '101.60': 101.6,\n",
       " '101.70': 101.7,\n",
       " '101.80': 101.8,\n",
       " '101.9': 101.9,\n",
       " '101.90': 101.9,\n",
       " '101.92': 101.92,\n",
       " '1010.6': 1010.6,\n",
       " '1011.2': 1011.2,\n",
       " '10112': 10112.0,\n",
       " '1012.41': 1012.41,\n",
       " '1013.01': 1013.01,\n",
       " '1017.5': 1017.5,\n",
       " '102.0': 102.0,\n",
       " '102.00': 102.0,\n",
       " '102.1': 102.1,\n",
       " '102.10': 102.1,\n",
       " '102.2': 102.2,\n",
       " '102.20': 102.2,\n",
       " '102.3': 102.3,\n",
       " '102.30': 102.3,\n",
       " '102.4': 102.4,\n",
       " '102.40': 102.4,\n",
       " '102.5': 102.5,\n",
       " '102.50': 102.5,\n",
       " '102.6': 102.6,\n",
       " '102.60': 102.6,\n",
       " '102.65': 102.65,\n",
       " '102.7': 102.7,\n",
       " '102.70': 102.7,\n",
       " '102.80': 102.8,\n",
       " '102.90': 102.9,\n",
       " '1020': 1020.0,\n",
       " '1020.0': 1020.0,\n",
       " '1020.36': 1020.36,\n",
       " '1020.51': 1020.51,\n",
       " '1025.76': 1025.76,\n",
       " '1026.0': 1026.0,\n",
       " '1029.6': 1029.6,\n",
       " '103.0': 103.0,\n",
       " '103.00': 103.0,\n",
       " '103.10': 103.1,\n",
       " '103.2': 103.2,\n",
       " '103.20': 103.2,\n",
       " '103.30': 103.3,\n",
       " '103.4': 103.4,\n",
       " '103.40': 103.4,\n",
       " '103.5': 103.5,\n",
       " '103.50': 103.5,\n",
       " '103.6': 103.6,\n",
       " '103.60': 103.6,\n",
       " '103.7': 103.7,\n",
       " '103.70': 103.7,\n",
       " '103.8': 103.8,\n",
       " '103.80': 103.8,\n",
       " '103.9': 103.9,\n",
       " '103.90': 103.9,\n",
       " '1030.4': 1030.4,\n",
       " '1034.6': 1034.6,\n",
       " '1034.76': 1034.76,\n",
       " '1035.53': 1035.53,\n",
       " '1036.8': 1036.8,\n",
       " '104.0': 104.0,\n",
       " '104.00': 104.0,\n",
       " '104.1': 104.1,\n",
       " '104.10': 104.1,\n",
       " '104.20': 104.2,\n",
       " '104.3': 104.3,\n",
       " '104.30': 104.3,\n",
       " '104.4': 104.4,\n",
       " '104.40': 104.4,\n",
       " '104.5': 104.5,\n",
       " '104.50': 104.5,\n",
       " '104.6': 104.6,\n",
       " '104.60': 104.6,\n",
       " '104.7': 104.7,\n",
       " '104.70': 104.7,\n",
       " '104.75': 104.75,\n",
       " '104.9': 104.9,\n",
       " '104.90': 104.9,\n",
       " '1043.63': 1043.63,\n",
       " '1045.8': 1045.8,\n",
       " '10465.0': 10465.0,\n",
       " '1049': 1049.0,\n",
       " '1049.78': 1049.78,\n",
       " '105.0': 105.0,\n",
       " '105.00': 105.0,\n",
       " '105.1': 105.1,\n",
       " '105.10': 105.1,\n",
       " '105.20': 105.2,\n",
       " '105.21': 105.21,\n",
       " '105.3': 105.3,\n",
       " '105.30': 105.3,\n",
       " '105.40': 105.4,\n",
       " '105.50': 105.5,\n",
       " '105.51': 105.51,\n",
       " '105.6': 105.6,\n",
       " '105.60': 105.6,\n",
       " '105.70': 105.7,\n",
       " '105.8': 105.8,\n",
       " '105.80': 105.8,\n",
       " '105.9': 105.9,\n",
       " '105.90': 105.9,\n",
       " '1050.53': 1050.53,\n",
       " '1050.8': 1050.8,\n",
       " '1053.53': 1053.53,\n",
       " '106.00': 106.0,\n",
       " '106.1': 106.1,\n",
       " '106.11': 106.11,\n",
       " '106.2': 106.2,\n",
       " '106.20': 106.2,\n",
       " '106.3': 106.3,\n",
       " '106.30': 106.3,\n",
       " '106.4': 106.4,\n",
       " '106.40': 106.4,\n",
       " '106.5': 106.5,\n",
       " '106.50': 106.5,\n",
       " '106.56': 106.56,\n",
       " '106.6': 106.6,\n",
       " '106.60': 106.6,\n",
       " '106.70': 106.7,\n",
       " '106.8': 106.8,\n",
       " '106.80': 106.8,\n",
       " '106.86': 106.86,\n",
       " '106.9': 106.9,\n",
       " '106.90': 106.9,\n",
       " '1064.78': 1064.78,\n",
       " '1066.7': 1066.7,\n",
       " '1067.04': 1067.04,\n",
       " '1069.29': 1069.29,\n",
       " '1069.6': 1069.6,\n",
       " '107.00': 107.0,\n",
       " '107.01': 107.01,\n",
       " '107.1': 107.1,\n",
       " '107.10': 107.1,\n",
       " '107.16': 107.16,\n",
       " '107.20': 107.2,\n",
       " '107.30': 107.3,\n",
       " '107.31': 107.31,\n",
       " '107.4': 107.4,\n",
       " '107.40': 107.4,\n",
       " '107.46': 107.46,\n",
       " '107.5': 107.5,\n",
       " '107.50': 107.5,\n",
       " '107.6': 107.6,\n",
       " '107.60': 107.6,\n",
       " '107.70': 107.7,\n",
       " '107.8': 107.8,\n",
       " '107.80': 107.8,\n",
       " '107.9': 107.9,\n",
       " '107.90': 107.9,\n",
       " '1074.4': 1074.4,\n",
       " '1077.84': 1077.84,\n",
       " '1077.9': 1077.9,\n",
       " '1079.1': 1079.1,\n",
       " '1079.94': 1079.94,\n",
       " '108.0': 108.0,\n",
       " '108.00': 108.0,\n",
       " '108.04': 108.04,\n",
       " '108.1': 108.1,\n",
       " '108.10': 108.1,\n",
       " '108.2': 108.2,\n",
       " '108.20': 108.2,\n",
       " '108.30': 108.3,\n",
       " '108.36': 108.36,\n",
       " '108.4': 108.4,\n",
       " '108.40': 108.4,\n",
       " '108.5': 108.5,\n",
       " '108.50': 108.5,\n",
       " '108.54': 108.54,\n",
       " '108.60': 108.6,\n",
       " '108.70': 108.7,\n",
       " '108.8': 108.8,\n",
       " '108.80': 108.8,\n",
       " '108.90': 108.9,\n",
       " '1080.39': 1080.39,\n",
       " '1080.54': 1080.54,\n",
       " '1084.14': 1084.14,\n",
       " '1084.29': 1084.29,\n",
       " '1088.0': 1088.0,\n",
       " '1089': 1089.0,\n",
       " '109.0': 109.0,\n",
       " '109.00': 109.0,\n",
       " '109.10': 109.1,\n",
       " '109.2': 109.2,\n",
       " '109.20': 109.2,\n",
       " '109.30': 109.3,\n",
       " '109.40': 109.4,\n",
       " '109.5': 109.5,\n",
       " '109.50': 109.5,\n",
       " '109.6': 109.6,\n",
       " '109.60': 109.6,\n",
       " '109.7': 109.7,\n",
       " '109.70': 109.7,\n",
       " '109.71': 109.71,\n",
       " '109.80': 109.8,\n",
       " '109.9': 109.9,\n",
       " '109.90': 109.9,\n",
       " '1090.2': 1090.2,\n",
       " '1092.0': 1092.0,\n",
       " '1094.79': 1094.79,\n",
       " '1098': 1098.0,\n",
       " '11.0': 11.0,\n",
       " '11.00': 11.0,\n",
       " '11.1': 11.1,\n",
       " '11.10': 11.1,\n",
       " '11.2': 11.2,\n",
       " '11.20': 11.2,\n",
       " '11.3': 11.3,\n",
       " '11.30': 11.3,\n",
       " '11.4': 11.4,\n",
       " '11.40': 11.4,\n",
       " '11.5': 11.5,\n",
       " '11.50': 11.5,\n",
       " '11.6': 11.6,\n",
       " '11.60': 11.6,\n",
       " '11.7': 11.7,\n",
       " '11.70': 11.7,\n",
       " '11.8': 11.8,\n",
       " '11.80': 11.8,\n",
       " '11.9': 11.9,\n",
       " '11.90': 11.9,\n",
       " '110.0': 110.0,\n",
       " '110.00': 110.0,\n",
       " '110.01': 110.01,\n",
       " '110.1': 110.1,\n",
       " '110.10': 110.1,\n",
       " '110.2': 110.2,\n",
       " '110.20': 110.2,\n",
       " '110.3': 110.3,\n",
       " '110.40': 110.4,\n",
       " '110.46': 110.46,\n",
       " '110.50': 110.5,\n",
       " '110.6': 110.6,\n",
       " '110.60': 110.6,\n",
       " '110.7': 110.7,\n",
       " '110.70': 110.7,\n",
       " '110.76': 110.76,\n",
       " '110.80': 110.8,\n",
       " '110.9': 110.9,\n",
       " '110.90': 110.9,\n",
       " '110.92': 110.92,\n",
       " '1109.81': 1109.81,\n",
       " '111.0': 111.0,\n",
       " '111.00': 111.0,\n",
       " '111.06': 111.06,\n",
       " '111.10': 111.1,\n",
       " '111.2': 111.2,\n",
       " '111.20': 111.2,\n",
       " '111.21': 111.21,\n",
       " '111.30': 111.3,\n",
       " '111.33': 111.33,\n",
       " '111.4': 111.4,\n",
       " '111.40': 111.4,\n",
       " '111.5': 111.5,\n",
       " '111.50': 111.5,\n",
       " '111.51': 111.51,\n",
       " '111.60': 111.6,\n",
       " '111.7': 111.7,\n",
       " '111.70': 111.7,\n",
       " '111.8': 111.8,\n",
       " '111.80': 111.8,\n",
       " '111.9': 111.9,\n",
       " '111.90': 111.9,\n",
       " '111.96': 111.96,\n",
       " '1110.56': 1110.56,\n",
       " '1112.06': 1112.06,\n",
       " '112.0': 112.0,\n",
       " '112.00': 112.0,\n",
       " '112.1': 112.1,\n",
       " '112.10': 112.1,\n",
       " '112.11': 112.11,\n",
       " '112.2': 112.2,\n",
       " '112.20': 112.2,\n",
       " '112.26': 112.26,\n",
       " '112.3': 112.3,\n",
       " '112.30': 112.3,\n",
       " '112.40': 112.4,\n",
       " '112.41': 112.41,\n",
       " '112.5': 112.5,\n",
       " '112.50': 112.5,\n",
       " '112.56': 112.56,\n",
       " '112.6': 112.6,\n",
       " '112.60': 112.6,\n",
       " '112.7': 112.7,\n",
       " '112.70': 112.7,\n",
       " '112.8': 112.8,\n",
       " '112.80': 112.8,\n",
       " '112.9': 112.9,\n",
       " '112.90': 112.9,\n",
       " '1122.56': 1122.56,\n",
       " '1123.2': 1123.2,\n",
       " '1125.57': 1125.57,\n",
       " '1126.4': 1126.4,\n",
       " '1129.4': 1129.4,\n",
       " '113.0': 113.0,\n",
       " '113.00': 113.0,\n",
       " '113.1': 113.1,\n",
       " '113.10': 113.1,\n",
       " '113.2': 113.2,\n",
       " '113.20': 113.2,\n",
       " '113.3': 113.3,\n",
       " '113.30': 113.3,\n",
       " '113.4': 113.4,\n",
       " '113.40': 113.4,\n",
       " '113.5': 113.5,\n",
       " '113.50': 113.5,\n",
       " '113.70': 113.7,\n",
       " '113.76': 113.76,\n",
       " '113.8': 113.8,\n",
       " '113.80': 113.8,\n",
       " '113.9': 113.9,\n",
       " '113.90': 113.9,\n",
       " '1131.0': 1131.0,\n",
       " '11310.0': 11310.0,\n",
       " '11336.0': 11336.0,\n",
       " '1134.57': 1134.57,\n",
       " '1137.8': 1137.8,\n",
       " '1138.5': 1138.5,\n",
       " '114.0': 114.0,\n",
       " '114.00': 114.0,\n",
       " '114.10': 114.1,\n",
       " '114.2': 114.2,\n",
       " '114.20': 114.2,\n",
       " '114.21': 114.21,\n",
       " '114.30': 114.3,\n",
       " '114.4': 114.4,\n",
       " '114.40': 114.4,\n",
       " '114.5': 114.5,\n",
       " '114.50': 114.5,\n",
       " '114.6': 114.6,\n",
       " '114.60': 114.6,\n",
       " '114.66': 114.66,\n",
       " '114.70': 114.7,\n",
       " '114.8': 114.8,\n",
       " '114.80': 114.8,\n",
       " '114.81': 114.81,\n",
       " '114.9': 114.9,\n",
       " '114.90': 114.9,\n",
       " '114.92': 114.92,\n",
       " '1142.4': 1142.4,\n",
       " '1145.5': 1145.5,\n",
       " '1147.47': 1147.47,\n",
       " '1147.92': 1147.92,\n",
       " '1148.07': 1148.07,\n",
       " '115.00': 115.0,\n",
       " '115.1': 115.1,\n",
       " '115.10': 115.1,\n",
       " '115.11': 115.11,\n",
       " '115.2': 115.2,\n",
       " '115.20': 115.2,\n",
       " '115.26': 115.26,\n",
       " '115.3': 115.3,\n",
       " '115.30': 115.3,\n",
       " '115.4': 115.4,\n",
       " '115.40': 115.4,\n",
       " '115.41': 115.41,\n",
       " '115.50': 115.5,\n",
       " '115.56': 115.56,\n",
       " '115.6': 115.6,\n",
       " '115.60': 115.6,\n",
       " '115.63': 115.63,\n",
       " '115.7': 115.7,\n",
       " '115.70': 115.7,\n",
       " '115.80': 115.8,\n",
       " '115.86': 115.86,\n",
       " '115.9': 115.9,\n",
       " '115.90': 115.9,\n",
       " '1154.6': 1154.6,\n",
       " '1154.82': 1154.82,\n",
       " '1159.2': 1159.2,\n",
       " '116.0': 116.0,\n",
       " '116.00': 116.0,\n",
       " '116.1': 116.1,\n",
       " '116.10': 116.1,\n",
       " '116.2': 116.2,\n",
       " '116.20': 116.2,\n",
       " '116.25': 116.25,\n",
       " '116.30': 116.3,\n",
       " '116.31': 116.31,\n",
       " '116.40': 116.4,\n",
       " '116.46': 116.46,\n",
       " '116.50': 116.5,\n",
       " '116.6': 116.6,\n",
       " '116.60': 116.6,\n",
       " '116.62': 116.62,\n",
       " '116.70': 116.7,\n",
       " '116.8': 116.8,\n",
       " '116.80': 116.8,\n",
       " '116.82': 116.82,\n",
       " '116.9': 116.9,\n",
       " '116.90': 116.9,\n",
       " '1161.59': 1161.59,\n",
       " '1162.1': 1162.1,\n",
       " '1162.5': 1162.5,\n",
       " '1168.0': 1168.0,\n",
       " '1169.2': 1169.2,\n",
       " '117.0': 117.0,\n",
       " '117.00': 117.0,\n",
       " '117.1': 117.1,\n",
       " '117.10': 117.1,\n",
       " '117.20': 117.2,\n",
       " '117.3': 117.3,\n",
       " '117.30': 117.3,\n",
       " '117.4': 117.4,\n",
       " '117.40': 117.4,\n",
       " '117.41': 117.41,\n",
       " '117.44': 117.44,\n",
       " '117.5': 117.5,\n",
       " '117.50': 117.5,\n",
       " '117.53': 117.53,\n",
       " '117.6': 117.6,\n",
       " '117.60': 117.6,\n",
       " '117.66': 117.66,\n",
       " '117.70': 117.7,\n",
       " '117.71': 117.71,\n",
       " '117.8': 117.8,\n",
       " '117.80': 117.8,\n",
       " '117.90': 117.9,\n",
       " '117.96': 117.96,\n",
       " '1170.0': 1170.0,\n",
       " '11700.0': 11700.0,\n",
       " '1173.59': 1173.59,\n",
       " '118.00': 118.0,\n",
       " '118.10': 118.1,\n",
       " '118.11': 118.11,\n",
       " '118.20': 118.2,\n",
       " '118.26': 118.26,\n",
       " '118.3': 118.3,\n",
       " '118.30': 118.3,\n",
       " '118.4': 118.4,\n",
       " '118.40': 118.4,\n",
       " '118.41': 118.41,\n",
       " '118.5': 118.5,\n",
       " '118.50': 118.5,\n",
       " '118.56': 118.56,\n",
       " '118.6': 118.6,\n",
       " '118.60': 118.6,\n",
       " '118.7': 118.7,\n",
       " '118.70': 118.7,\n",
       " '118.71': 118.71,\n",
       " '118.75': 118.75,\n",
       " '118.80': 118.8,\n",
       " '1185': 1185.0,\n",
       " '1185.0': 1185.0,\n",
       " '1185.6': 1185.6,\n",
       " '119.0': 119.0,\n",
       " '119.00': 119.0,\n",
       " '119.04': 119.04,\n",
       " '119.2': 119.2,\n",
       " '119.20': 119.2,\n",
       " '119.3': 119.3,\n",
       " '119.30': 119.3,\n",
       " '119.31': 119.31,\n",
       " '119.40': 119.4,\n",
       " '119.5': 119.5,\n",
       " '119.50': 119.5,\n",
       " '119.6': 119.6,\n",
       " '119.60': 119.6,\n",
       " '119.61': 119.61,\n",
       " '119.7': 119.7,\n",
       " '119.70': 119.7,\n",
       " '119.76': 119.76,\n",
       " '119.80': 119.8,\n",
       " '119.9': 119.9,\n",
       " '1192.8': 1192.8,\n",
       " '1194.0': 1194.0,\n",
       " '1199.85': 1199.85,\n",
       " '12.0': 12.0,\n",
       " '12.00': 12.0,\n",
       " '12.1': 12.1,\n",
       " '12.10': 12.1,\n",
       " '12.2': 12.2,\n",
       " '12.20': 12.2,\n",
       " '12.24': 12.24,\n",
       " '12.3': 12.3,\n",
       " '12.30': 12.3,\n",
       " '12.4': 12.4,\n",
       " '12.40': 12.4,\n",
       " '12.5': 12.5,\n",
       " '12.50': 12.5,\n",
       " '12.6': 12.6,\n",
       " '12.60': 12.6,\n",
       " '12.64': 12.64,\n",
       " '12.7': 12.7,\n",
       " '12.70': 12.7,\n",
       " '12.8': 12.8,\n",
       " '12.80': 12.8,\n",
       " '12.87': 12.87,\n",
       " '12.88': 12.88,\n",
       " '12.9': 12.9,\n",
       " '12.90': 12.9,\n",
       " '12.95': 12.95,\n",
       " '120.0': 120.0,\n",
       " '120.00': 120.0,\n",
       " '120.1': 120.1,\n",
       " '120.10': 120.1,\n",
       " '120.3': 120.3,\n",
       " '120.30': 120.3,\n",
       " '120.4': 120.4,\n",
       " '120.50': 120.5,\n",
       " '120.60': 120.6,\n",
       " '120.7': 120.7,\n",
       " '120.70': 120.7,\n",
       " '120.8': 120.8,\n",
       " '120.80': 120.8,\n",
       " '120.9': 120.9,\n",
       " '120.90': 120.9,\n",
       " '120.96': 120.96,\n",
       " '1200': 1200.0,\n",
       " '1200.6': 1200.6,\n",
       " '1200.8': 1200.8,\n",
       " '121.0': 121.0,\n",
       " '121.00': 121.0,\n",
       " '121.10': 121.1,\n",
       " '121.20': 121.2,\n",
       " '121.26': 121.26,\n",
       " '121.30': 121.3,\n",
       " '121.4': 121.4,\n",
       " '121.40': 121.4,\n",
       " '121.41': 121.41,\n",
       " '121.5': 121.5,\n",
       " '121.50': 121.5,\n",
       " '121.6': 121.6,\n",
       " '121.60': 121.6,\n",
       " '121.65': 121.65,\n",
       " '121.7': 121.7,\n",
       " '121.70': 121.7,\n",
       " '121.80': 121.8,\n",
       " '121.90': 121.9,\n",
       " '1211.85': 1211.85,\n",
       " '1212.6': 1212.6,\n",
       " '1215': 1215.0,\n",
       " '1215.45': 1215.45,\n",
       " '1215.62': 1215.62,\n",
       " '1216': 1216.0,\n",
       " '1218.62': 1218.62,\n",
       " '122.00': 122.0,\n",
       " '122.10': 122.1,\n",
       " '122.2': 122.2,\n",
       " '122.20': 122.2,\n",
       " '122.30': 122.3,\n",
       " '122.4': 122.4,\n",
       " '122.40': 122.4,\n",
       " '122.46': 122.46,\n",
       " '122.5': 122.5,\n",
       " '122.50': 122.5,\n",
       " '122.6': 122.6,\n",
       " '122.60': 122.6,\n",
       " '122.61': 122.61,\n",
       " '122.70': 122.7,\n",
       " '122.76': 122.76,\n",
       " '122.8': 122.8,\n",
       " '122.80': 122.8,\n",
       " '122.90': 122.9,\n",
       " '122.91': 122.91,\n",
       " '1226.7': 1226.7,\n",
       " '123.0': 123.0,\n",
       " '123.00': 123.0,\n",
       " '123.1': 123.1,\n",
       " '123.10': 123.1,\n",
       " '123.2': 123.2,\n",
       " '123.20': 123.2,\n",
       " '123.21': 123.21,\n",
       " '123.3': 123.3,\n",
       " '123.30': 123.3,\n",
       " '123.36': 123.36,\n",
       " '123.4': 123.4,\n",
       " '123.40': 123.4,\n",
       " '123.50': 123.5,\n",
       " '123.60': 123.6,\n",
       " '123.66': 123.66,\n",
       " '123.7': 123.7,\n",
       " '123.70': 123.7,\n",
       " '123.75': 123.75,\n",
       " '123.8': 123.8,\n",
       " '123.80': 123.8,\n",
       " '123.81': 123.81,\n",
       " '123.90': 123.9,\n",
       " '1236.62': 1236.62,\n",
       " '124.00': 124.0,\n",
       " '124.1': 124.1,\n",
       " '124.10': 124.1,\n",
       " '124.11': 124.11,\n",
       " '124.20': 124.2,\n",
       " '124.3': 124.3,\n",
       " '124.30': 124.3,\n",
       " '124.40': 124.4,\n",
       " '124.41': 124.41,\n",
       " '124.5': 124.5,\n",
       " '124.50': 124.5,\n",
       " '124.60': 124.6,\n",
       " '124.7': 124.7,\n",
       " '124.70': 124.7,\n",
       " '124.71': 124.71,\n",
       " '124.8': 124.8,\n",
       " '124.80': 124.8,\n",
       " '1248.2': 1248.2,\n",
       " '1249.98': 1249.98,\n",
       " '125.00': 125.0,\n",
       " '125.01': 125.01,\n",
       " '125.1': 125.1,\n",
       " '125.10': 125.1,\n",
       " '125.3': 125.3,\n",
       " '125.30': 125.3,\n",
       " '125.31': 125.31,\n",
       " '125.4': 125.4,\n",
       " '125.40': 125.4,\n",
       " '125.46': 125.46,\n",
       " '125.5': 125.5,\n",
       " '125.50': 125.5,\n",
       " '125.6': 125.6,\n",
       " '125.60': 125.6,\n",
       " '125.61': 125.61,\n",
       " '125.70': 125.7,\n",
       " '125.8': 125.8,\n",
       " '125.80': 125.8,\n",
       " '125.90': 125.9,\n",
       " '125.91': 125.91,\n",
       " '1250.13': 1250.13,\n",
       " '1255.6': 1255.6,\n",
       " '1259.88': 1259.88,\n",
       " '126.0': 126.0,\n",
       " '126.00': 126.0,\n",
       " '126.06': 126.06,\n",
       " '126.20': 126.2,\n",
       " '126.21': 126.21,\n",
       " '126.30': 126.3,\n",
       " '126.36': 126.36,\n",
       " '126.4': 126.4,\n",
       " '126.40': 126.4,\n",
       " '126.49': 126.49,\n",
       " '126.5': 126.5,\n",
       " '126.50': 126.5,\n",
       " '126.57': 126.57,\n",
       " '126.60': 126.6,\n",
       " '126.66': 126.66,\n",
       " '126.7': 126.7,\n",
       " '126.70': 126.7,\n",
       " '126.8': 126.8,\n",
       " '126.81': 126.81,\n",
       " '126.9': 126.9,\n",
       " '126.90': 126.9,\n",
       " '126.96': 126.96,\n",
       " '1260.0': 1260.0,\n",
       " '1260.63': 1260.63,\n",
       " '1262.73': 1262.73,\n",
       " '1262.88': 1262.88,\n",
       " '1264': 1264.0,\n",
       " '12640': 12640.0,\n",
       " '1266.5': 1266.5,\n",
       " '127.00': 127.0,\n",
       " '127.1': 127.1,\n",
       " '127.10': 127.1,\n",
       " '127.20': 127.2,\n",
       " '127.3': 127.3,\n",
       " '127.30': 127.3,\n",
       " '127.4': 127.4,\n",
       " '127.40': 127.4,\n",
       " '127.5': 127.5,\n",
       " '127.50': 127.5,\n",
       " '127.56': 127.56,\n",
       " '127.60': 127.6,\n",
       " '127.7': 127.7,\n",
       " '127.70': 127.7,\n",
       " '127.8': 127.8,\n",
       " '127.80': 127.8,\n",
       " '127.86': 127.86,\n",
       " '127.90': 127.9,\n",
       " '1271.88': 1271.88,\n",
       " '1274.88': 1274.88,\n",
       " '1275.48': 1275.48,\n",
       " '1275.65': 1275.65,\n",
       " '1278.4': 1278.4,\n",
       " '128.0': 128.0,\n",
       " '128.00': 128.0,\n",
       " '128.01': 128.01,\n",
       " '128.1': 128.1,\n",
       " '128.10': 128.1,\n",
       " '128.16': 128.16,\n",
       " '128.20': 128.2,\n",
       " '128.30': 128.3,\n",
       " '128.31': 128.31,\n",
       " '128.40': 128.4,\n",
       " '128.5': 128.5,\n",
       " '128.50': 128.5,\n",
       " '128.6': 128.6,\n",
       " '128.60': 128.6,\n",
       " '128.7': 128.7,\n",
       " '128.70': 128.7,\n",
       " '128.8': 128.8,\n",
       " '128.80': 128.8,\n",
       " '128.90': 128.9,\n",
       " '1282.4': 1282.4,\n",
       " '1287.0': 1287.0,\n",
       " '12870.0': 12870.0,\n",
       " '129.0': 129.0,\n",
       " '129.00': 129.0,\n",
       " '129.06': 129.06,\n",
       " '129.10': 129.1,\n",
       " '129.2': 129.2,\n",
       " '129.20': 129.2,\n",
       " '129.21': 129.21,\n",
       " '129.3': 129.3,\n",
       " '129.30': 129.3,\n",
       " '129.36': 129.36,\n",
       " '129.4': 129.4,\n",
       " '129.40': 129.4,\n",
       " '129.5': 129.5,\n",
       " '129.50': 129.5,\n",
       " '129.51': 129.51,\n",
       " '129.6': 129.6,\n",
       " '129.60': 129.6,\n",
       " '129.66': 129.66,\n",
       " '129.70': 129.7,\n",
       " '129.80': 129.8,\n",
       " '129.81': 129.81,\n",
       " '129.9': 129.9,\n",
       " '129.90': 129.9,\n",
       " '1290.65': 1290.65,\n",
       " '1292.2': 1292.2,\n",
       " '12960.0': 12960.0,\n",
       " '1298': 1298.0,\n",
       " '13.0': 13.0,\n",
       " '13.00': 13.0,\n",
       " '13.1': 13.1,\n",
       " '13.10': 13.1,\n",
       " '13.2': 13.2,\n",
       " '13.20': 13.2,\n",
       " '13.28': 13.28,\n",
       " '13.3': 13.3,\n",
       " '13.30': 13.3,\n",
       " '13.4': 13.4,\n",
       " '13.40': 13.4,\n",
       " '13.5': 13.5,\n",
       " '13.50': 13.5,\n",
       " '13.6': 13.6,\n",
       " '13.60': 13.6,\n",
       " '13.7': 13.7,\n",
       " '13.70': 13.7,\n",
       " '13.72': 13.72,\n",
       " '13.75': 13.75,\n",
       " '13.8': 13.8,\n",
       " '13.80': 13.8,\n",
       " '13.9': 13.9,\n",
       " '13.90': 13.9,\n",
       " '13.93': 13.93,\n",
       " '130.0': 130.0,\n",
       " '130.00': 130.0,\n",
       " '130.2': 130.2,\n",
       " '130.20': 130.2,\n",
       " '130.30': 130.3,\n",
       " '130.4': 130.4,\n",
       " '130.40': 130.4,\n",
       " '130.5': 130.5,\n",
       " '130.50': 130.5,\n",
       " '130.6': 130.6,\n",
       " '130.60': 130.6,\n",
       " '130.69': 130.69,\n",
       " '130.7': 130.7,\n",
       " '130.70': 130.7,\n",
       " '130.80': 130.8,\n",
       " '130.9': 130.9,\n",
       " '130.90': 130.9,\n",
       " '1302': 1302.0,\n",
       " '1305.66': 1305.66,\n",
       " '1309.8': 1309.8,\n",
       " '131.0': 131.0,\n",
       " '131.00': 131.0,\n",
       " '131.1': 131.1,\n",
       " '131.10': 131.1,\n",
       " '131.14': 131.14,\n",
       " '131.2': 131.2,\n",
       " '131.20': 131.2,\n",
       " '131.3': 131.3,\n",
       " '131.30': 131.3,\n",
       " '131.4': 131.4,\n",
       " '131.40': 131.4,\n",
       " '131.46': 131.46,\n",
       " '131.50': 131.5,\n",
       " '131.60': 131.6,\n",
       " '131.61': 131.61,\n",
       " '131.70': 131.7,\n",
       " '131.80': 131.8,\n",
       " '131.90': 131.9,\n",
       " '131.91': 131.91,\n",
       " '1310.4': 1310.4,\n",
       " '1311.4': 1311.4,\n",
       " '1313.16': 1313.16,\n",
       " '1313.91': 1313.91,\n",
       " '132.0': 132.0,\n",
       " '132.00': 132.0,\n",
       " '132.06': 132.06,\n",
       " '132.10': 132.1,\n",
       " '132.20': 132.2,\n",
       " '132.21': 132.21,\n",
       " '132.30': 132.3,\n",
       " '132.40': 132.4,\n",
       " '132.50': 132.5,\n",
       " '132.51': 132.51,\n",
       " '132.6': 132.6,\n",
       " '132.60': 132.6,\n",
       " '132.66': 132.66,\n",
       " '132.7': 132.7,\n",
       " '132.70': 132.7,\n",
       " '132.75': 132.75,\n",
       " '132.8': 132.8,\n",
       " '132.80': 132.8,\n",
       " '1327.2': 1327.2,\n",
       " '133.0': 133.0,\n",
       " '133.00': 133.0,\n",
       " '133.10': 133.1,\n",
       " '133.20': 133.2,\n",
       " '133.3': 133.3,\n",
       " '133.30': 133.3,\n",
       " '133.32': 133.32,\n",
       " '133.40': 133.4,\n",
       " '133.5': 133.5,\n",
       " '133.50': 133.5,\n",
       " '133.6': 133.6,\n",
       " '133.60': 133.6,\n",
       " '133.65': 133.65,\n",
       " '133.70': 133.7,\n",
       " '133.80': 133.8,\n",
       " '133.90': 133.9,\n",
       " '1332.3': 1332.3,\n",
       " '1339.28': 1339.28,\n",
       " '1339.43': 1339.43,\n",
       " '134.0': 134.0,\n",
       " '134.00': 134.0,\n",
       " '134.01': 134.01,\n",
       " '134.05': 134.05,\n",
       " '134.10': 134.1,\n",
       " '134.2': 134.2,\n",
       " '134.20': 134.2,\n",
       " '134.3': 134.3,\n",
       " '134.30': 134.3,\n",
       " '134.31': 134.31,\n",
       " '134.4': 134.4,\n",
       " '134.40': 134.4,\n",
       " '134.46': 134.46,\n",
       " '134.50': 134.5,\n",
       " '134.52': 134.52,\n",
       " '134.6': 134.6,\n",
       " '134.70': 134.7,\n",
       " '134.76': 134.76,\n",
       " '134.80': 134.8,\n",
       " '134.91': 134.91,\n",
       " '134.94': 134.94,\n",
       " '1346.4': 1346.4,\n",
       " '1349.93': 1349.93,\n",
       " '135.0': 135.0,\n",
       " '135.00': 135.0,\n",
       " '135.08': 135.08,\n",
       " '135.10': 135.1,\n",
       " '135.2': 135.2,\n",
       " '135.20': 135.2,\n",
       " '135.21': 135.21,\n",
       " '135.23': 135.23,\n",
       " '135.3': 135.3,\n",
       " '135.30': 135.3,\n",
       " '135.31': 135.31,\n",
       " '135.40': 135.4,\n",
       " '135.5': 135.5,\n",
       " '135.50': 135.5,\n",
       " '135.60': 135.6,\n",
       " '135.7': 135.7,\n",
       " '135.70': 135.7,\n",
       " '135.8': 135.8,\n",
       " '135.80': 135.8,\n",
       " '1350': 1350.0,\n",
       " '1350.53': 1350.53,\n",
       " '1350.68': 1350.68,\n",
       " '136.0': 136.0,\n",
       " '136.00': 136.0,\n",
       " '136.1': 136.1,\n",
       " '136.10': 136.1,\n",
       " '136.13': 136.13,\n",
       " '136.2': 136.2,\n",
       " '136.20': 136.2,\n",
       " '136.3': 136.3,\n",
       " '136.30': 136.3,\n",
       " '136.43': 136.43,\n",
       " '136.50': 136.5,\n",
       " '136.6': 136.6,\n",
       " '136.60': 136.6,\n",
       " '136.70': 136.7,\n",
       " '136.73': 136.73,\n",
       " '136.8': 136.8,\n",
       " '136.80': 136.8,\n",
       " '136.88': 136.88,\n",
       " '1364.93': 1364.93,\n",
       " '137.00': 137.0,\n",
       " '137.03': 137.03,\n",
       " '137.10': 137.1,\n",
       " '137.2': 137.2,\n",
       " '137.20': 137.2,\n",
       " '137.3': 137.3,\n",
       " '137.30': 137.3,\n",
       " '137.40': 137.4,\n",
       " '137.5': 137.5,\n",
       " '137.50': 137.5,\n",
       " '137.6': 137.6,\n",
       " '137.70': 137.7,\n",
       " '137.78': 137.78,\n",
       " '137.8': 137.8,\n",
       " '137.80': 137.8,\n",
       " '137.89': 137.89,\n",
       " '137.90': 137.9,\n",
       " '137.93': 137.93,\n",
       " '1372.5': 1372.5,\n",
       " '13728.0': 13728.0,\n",
       " '1374.6': 1374.6,\n",
       " '1379.5': 1379.5,\n",
       " '138.00': 138.0,\n",
       " '138.10': 138.1,\n",
       " '138.20': 138.2,\n",
       " '138.23': 138.23,\n",
       " '138.3': 138.3,\n",
       " '138.4': 138.4,\n",
       " '138.40': 138.4,\n",
       " '138.5': 138.5,\n",
       " '138.50': 138.5,\n",
       " '138.53': 138.53,\n",
       " '138.6': 138.6,\n",
       " '138.60': 138.6,\n",
       " '138.7': 138.7,\n",
       " '138.70': 138.7,\n",
       " ...}"
      ]
     },
     "execution_count": 16,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "prices_trans_dict"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "0\n",
      "50\n",
      "100\n",
      "150\n",
      "200\n",
      "250\n",
      "300\n",
      "350\n",
      "400\n",
      "450\n",
      "500\n",
      "550\n",
      "600\n",
      "650\n",
      "700\n",
      "750\n",
      "800\n",
      "850\n",
      "900\n",
      "950\n",
      "1000\n",
      "1050\n",
      "1100\n",
      "1150\n",
      "1200\n",
      "1250\n",
      "1300\n",
      "1350\n",
      "1400\n",
      "1450\n",
      "1500\n",
      "1550\n",
      "1600\n",
      "1650\n",
      "1700\n",
      "1750\n",
      "1800\n",
      "1850\n",
      "1900\n",
      "1950\n",
      "2000\n",
      "2050\n",
      "2100\n",
      "2150\n",
      "2200\n",
      "2250\n",
      "2300\n",
      "2350\n",
      "2400\n",
      "2450\n",
      "2500\n",
      "2550\n",
      "2600\n",
      "2650\n",
      "2700\n",
      "2750\n",
      "2800\n",
      "2850\n",
      "2900\n",
      "2950\n",
      "3000\n",
      "3050\n",
      "3100\n",
      "3150\n",
      "3200\n",
      "3250\n",
      "3300\n",
      "3350\n",
      "3400\n",
      "3450\n",
      "3500\n",
      "3550\n",
      "3600\n",
      "3650\n",
      "3700\n",
      "3750\n",
      "3800\n",
      "3850\n",
      "3900\n",
      "3950\n",
      "4000\n",
      "4050\n",
      "4100\n",
      "4150\n",
      "4200\n",
      "4250\n",
      "4300\n",
      "4350\n",
      "4400\n",
      "4450\n",
      "4500\n",
      "4550\n",
      "4600\n",
      "4650\n",
      "4700\n",
      "4750\n",
      "4800\n",
      "4850\n",
      "4900\n",
      "4950\n",
      "5000\n",
      "5050\n",
      "5100\n",
      "5150\n",
      "5200\n",
      "5250\n",
      "5300\n",
      "5350\n",
      "5400\n",
      "5450\n",
      "5500\n",
      "5550\n",
      "5600\n",
      "5650\n",
      "5700\n",
      "5750\n",
      "5800\n",
      "5850\n",
      "5900\n",
      "5950\n",
      "6000\n",
      "6050\n",
      "6100\n",
      "6150\n",
      "6200\n",
      "6250\n",
      "6300\n",
      "6350\n",
      "6400\n",
      "6450\n",
      "6500\n",
      "6550\n",
      "6600\n",
      "6650\n",
      "6700\n",
      "6750\n",
      "6800\n",
      "6850\n",
      "6900\n",
      "6950\n",
      "7000\n",
      "7050\n",
      "7100\n",
      "7150\n",
      "7200\n",
      "7250\n"
     ]
    }
   ],
   "source": [
    "for i,(k,v) in enumerate(prices_trans_dict.items()):\n",
    "    books.update_many({\"price\":k},{\"$set\":{\"price\":v}})\n",
    "    if i%50 == 0:\n",
    "        print(i)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 24,
   "metadata": {},
   "outputs": [],
   "source": [
    "cur = books.find({\"star\":{\"$exists\":True}})"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 25,
   "metadata": {},
   "outputs": [],
   "source": [
    "stars = cur.distinct(\"star\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 29,
   "metadata": {},
   "outputs": [],
   "source": [
    "star_trans_dict = {i:float(i) for i in stars}"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 34,
   "metadata": {},
   "outputs": [],
   "source": [
    "for i,(k,v) in enumerate(star_trans_dict.items()):\n",
    "    books.update_many({\"star\":k},{\"$set\":{\"star\":v}})\n",
    "    print(i)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 35,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 41,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 39,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 40,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "[{'_id': '教育音像', 'num_tutorial': 1},\n",
       " {'_id': '美丽装扮', 'num_tutorial': 108},\n",
       " {'_id': '个人理财', 'num_tutorial': 80},\n",
       " {'_id': '地图/地理', 'num_tutorial': 23},\n",
       " {'_id': '恋爱与婚姻', 'num_tutorial': 1},\n",
       " {'_id': '政治军事', 'num_tutorial': 7335},\n",
       " {'_id': '计算机与互联网', 'num_tutorial': 3},\n",
       " {'_id': '美食', 'num_tutorial': 2696},\n",
       " {'_id': '港台圖書', 'num_tutorial': 16},\n",
       " {'_id': '大中专教材', 'num_tutorial': 2},\n",
       " {'_id': '烹饪美食与酒', 'num_tutorial': 2},\n",
       " {'_id': '孕产妇/育儿', 'num_tutorial': 99},\n",
       " {'_id': '风水/占卜', 'num_tutorial': 5},\n",
       " {'_id': '哲学与宗教', 'num_tutorial': 21},\n",
       " {'_id': '其他', 'num_tutorial': 1},\n",
       " {'_id': '科技', 'num_tutorial': 4},\n",
       " {'_id': '经济管理', 'num_tutorial': 47},\n",
       " {'_id': '家庭教育', 'num_tutorial': 239},\n",
       " {'_id': '娱乐', 'num_tutorial': 3},\n",
       " {'_id': '励志与成功', 'num_tutorial': 13},\n",
       " {'_id': '科学与自然', 'num_tutorial': 28},\n",
       " {'_id': '外语学习', 'num_tutorial': 18},\n",
       " {'_id': '农业/林业', 'num_tutorial': 2529},\n",
       " {'_id': '时尚/美妆', 'num_tutorial': 283},\n",
       " {'_id': '自然科学', 'num_tutorial': 1252},\n",
       " {'_id': '工具书', 'num_tutorial': 138},\n",
       " {'_id': None, 'num_tutorial': 830},\n",
       " {'_id': '英文原版书', 'num_tutorial': 4172},\n",
       " {'_id': '法律', 'num_tutorial': 6506},\n",
       " {'_id': '手工/DIY', 'num_tutorial': 255},\n",
       " {'_id': '家庭/家居', 'num_tutorial': 343},\n",
       " {'_id': '医学', 'num_tutorial': 5460},\n",
       " {'_id': '考试', 'num_tutorial': 3215},\n",
       " {'_id': '收藏/鉴赏', 'num_tutorial': 39},\n",
       " {'_id': '动漫/幽默', 'num_tutorial': 1049},\n",
       " {'_id': '工业技术', 'num_tutorial': 6517},\n",
       " {'_id': '古籍', 'num_tutorial': 1550},\n",
       " {'_id': '育儿/早教', 'num_tutorial': 430},\n",
       " {'_id': '政治与军事', 'num_tutorial': 19},\n",
       " {'_id': '体育/运动', 'num_tutorial': 1170},\n",
       " {'_id': '社会科学', 'num_tutorial': 10592},\n",
       " {'_id': '旅游', 'num_tutorial': 2284},\n",
       " {'_id': '艺术与摄影', 'num_tutorial': 23},\n",
       " {'_id': '', 'num_tutorial': 9795},\n",
       " {'_id': '烹饪/美食', 'num_tutorial': 850},\n",
       " {'_id': '保健/养生', 'num_tutorial': 2200},\n",
       " {'_id': '文创', 'num_tutorial': 3},\n",
       " {'_id': '旅游与地图', 'num_tutorial': 15},\n",
       " {'_id': '传记', 'num_tutorial': 2129},\n",
       " {'_id': '养生保健', 'num_tutorial': 8},\n",
       " {'_id': '管理', 'num_tutorial': 6228},\n",
       " {'_id': '旅游/地图', 'num_tutorial': 831},\n",
       " {'_id': '经济', 'num_tutorial': 3048},\n",
       " {'_id': '计算机/网络', 'num_tutorial': 6115},\n",
       " {'_id': '青春动漫', 'num_tutorial': 17},\n",
       " {'_id': '科普读物', 'num_tutorial': 2346},\n",
       " {'_id': '心理学', 'num_tutorial': 893},\n",
       " {'_id': '教材', 'num_tutorial': 35642},\n",
       " {'_id': '童书', 'num_tutorial': 48465},\n",
       " {'_id': '历史', 'num_tutorial': 10265},\n",
       " {'_id': '亲子/家教', 'num_tutorial': 1008},\n",
       " {'_id': '辞典与工具书', 'num_tutorial': 10},\n",
       " {'_id': '休闲/爱好', 'num_tutorial': 383},\n",
       " {'_id': '政治/军事', 'num_tutorial': 3224},\n",
       " {'_id': '投资理财', 'num_tutorial': 898},\n",
       " {'_id': '文化', 'num_tutorial': 4521},\n",
       " {'_id': '小说', 'num_tutorial': 23271},\n",
       " {'_id': '建筑', 'num_tutorial': 2412},\n",
       " {'_id': '外语', 'num_tutorial': 13150},\n",
       " {'_id': '两性关系', 'num_tutorial': 118},\n",
       " {'_id': '进口原版', 'num_tutorial': 272},\n",
       " {'_id': '孕产育儿', 'num_tutorial': 2},\n",
       " {'_id': '中小学教辅', 'num_tutorial': 15695},\n",
       " {'_id': '少儿', 'num_tutorial': 29694},\n",
       " {'_id': '成功/励志', 'num_tutorial': 3636},\n",
       " {'_id': '哲学/宗教', 'num_tutorial': 8566},\n",
       " {'_id': '孕产/胎教', 'num_tutorial': 428},\n",
       " {'_id': '青春文学', 'num_tutorial': 7372},\n",
       " {'_id': '家居/休闲游戏', 'num_tutorial': 2556},\n",
       " {'_id': '保健/心理健康', 'num_tutorial': 154},\n",
       " {'_id': '艺术', 'num_tutorial': 22610},\n",
       " {'_id': '国学', 'num_tutorial': 3},\n",
       " {'_id': '文学', 'num_tutorial': 24186}]"
      ]
     },
     "execution_count": 40,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.6.4"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}
